<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.20"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>libxlsxwriter: panes.c</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="customdoxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">libxlsxwriter
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.20 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
</div><!-- top -->
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="headertitle">
<div class="title">panes.c</div>  </div>
</div><!--header-->
<div class="contents">
<table width="600">
<tr>
<td><a class="el" href="hide_row_col_8c-example.html">&lt;&lt; hide_row_col.c</a> </td><td align="right"><a class="el" href="ignore_errors_8c-example.html">ignore_errors.c &gt;&gt;</a>  </td></tr>
</table>
<p>An example of how to create panes in a worksheet, both "freeze" panes and "split" panes.</p>
<div class="image">
<img src="panes.png" alt=""/>
</div>
<div class="fragment"><div class="line"><span class="comment">/*</span></div>
<div class="line"><span class="comment"> * A simple example using the libxlsxwriter library to create worksheets with</span></div>
<div class="line"><span class="comment"> * panes.</span></div>
<div class="line"><span class="comment"> *</span></div>
<div class="line"><span class="comment"> * Copyright 2014-2018, John McNamara, jmcnamara@cpan.org</span></div>
<div class="line"><span class="comment"> *</span></div>
<div class="line"><span class="comment"> */</span></div>
<div class="line"> </div>
<div class="line"><span class="preprocessor">#include &quot;xlsxwriter.h&quot;</span></div>
<div class="line"> </div>
<div class="line"><span class="keywordtype">int</span> main() {</div>
<div class="line"> </div>
<div class="line">    <span class="keywordtype">int</span> row;</div>
<div class="line">    <span class="keywordtype">int</span> col;</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Create a new workbook and add some worksheets. */</span></div>
<div class="line">    <a name="_a0"></a><a class="code" href="structlxw__workbook.html">lxw_workbook</a>  *workbook   = <a name="a1"></a><a class="code" href="workbook_8h.html#a1cf96608a23ee4eb0e8467c15240d00b">workbook_new</a>(<span class="stringliteral">&quot;panes.xlsx&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <a name="_a2"></a><a class="code" href="structlxw__worksheet.html">lxw_worksheet</a> *worksheet1 = <a name="a3"></a><a class="code" href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a>(workbook, <span class="stringliteral">&quot;Panes 1&quot;</span>);</div>
<div class="line">    <a class="code" href="structlxw__worksheet.html">lxw_worksheet</a> *worksheet2 = <a class="code" href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a>(workbook, <span class="stringliteral">&quot;Panes 2&quot;</span>);</div>
<div class="line">    <a class="code" href="structlxw__worksheet.html">lxw_worksheet</a> *worksheet3 = <a class="code" href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a>(workbook, <span class="stringliteral">&quot;Panes 3&quot;</span>);</div>
<div class="line">    <a class="code" href="structlxw__worksheet.html">lxw_worksheet</a> *worksheet4 = <a class="code" href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a>(workbook, <span class="stringliteral">&quot;Panes 4&quot;</span>);</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Set up some formatting and text to highlight the panes. */</span></div>
<div class="line">    <a name="_a4"></a><a class="code" href="structlxw__format.html">lxw_format</a> *header = <a name="a5"></a><a class="code" href="workbook_8h.html#a279a5d7075d09a3931aae9782afede33">workbook_add_format</a>(workbook);</div>
<div class="line">    <a name="a6"></a><a class="code" href="format_8h.html#a189c83d1f21b01937f1f730720c33d13">format_set_align</a>(header, <a name="a7"></a><a class="code" href="format_8h.html#adeeb0d70c7c873422d642323e7e1ecf5a9899936ef3a43721b394b9b5d2314496">LXW_ALIGN_CENTER</a>);</div>
<div class="line">    <a class="code" href="format_8h.html#a189c83d1f21b01937f1f730720c33d13">format_set_align</a>(header, <a name="a8"></a><a class="code" href="format_8h.html#adeeb0d70c7c873422d642323e7e1ecf5ae0a52569d3110521d3e9341809336063">LXW_ALIGN_VERTICAL_CENTER</a>);</div>
<div class="line">    <a name="a9"></a><a class="code" href="format_8h.html#a65086b2b6ee51fd34893e3c53e0578eb">format_set_fg_color</a>(header, 0xD7E4BC);</div>
<div class="line">    <a name="a10"></a><a class="code" href="format_8h.html#a85e1b0baf44b445b65894e48722aec14">format_set_bold</a>(header);</div>
<div class="line">    <a name="a11"></a><a class="code" href="format_8h.html#a9cf7a28a6e8014cb98dff27415e2b1ca">format_set_border</a>(header, <a name="a12"></a><a class="code" href="format_8h.html#a4d5e924b1acd9571fd5e0fe2615e9f8fa7ca212fb42e5816bb81d7b96ff623082">LXW_BORDER_THIN</a>);</div>
<div class="line"> </div>
<div class="line">    <a class="code" href="structlxw__format.html">lxw_format</a> *center = <a class="code" href="workbook_8h.html#a279a5d7075d09a3931aae9782afede33">workbook_add_format</a>(workbook);</div>
<div class="line">    <a class="code" href="format_8h.html#a189c83d1f21b01937f1f730720c33d13">format_set_align</a>(center, <a class="code" href="format_8h.html#adeeb0d70c7c873422d642323e7e1ecf5a9899936ef3a43721b394b9b5d2314496">LXW_ALIGN_CENTER</a>);</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/*</span></div>
<div class="line"><span class="comment">     * Example 1. Freeze pane on the top row.</span></div>
<div class="line"><span class="comment">     */</span></div>
<div class="line">    <a name="a13"></a><a class="code" href="worksheet_8h.html#a7e52f1eecb20fe4f9e6223bcf195103b">worksheet_freeze_panes</a>(worksheet1, 1, 0);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Some sheet formatting. */</span></div>
<div class="line">    <a name="a14"></a><a class="code" href="worksheet_8h.html#a9656e4e05d3787eee6b3e4d8e82d9b7f">worksheet_set_column</a>(worksheet1, 0, 8, 16, NULL);</div>
<div class="line">    <a name="a15"></a><a class="code" href="worksheet_8h.html#ab9b7fb95e1bd9b0da70befd0d37a9173">worksheet_set_row</a>(worksheet1, 0, 20, NULL);</div>
<div class="line">    <a name="a16"></a><a class="code" href="worksheet_8h.html#a62368aa313184d72a9ca2b1cf5de9a8a">worksheet_set_selection</a>(worksheet1, 4, 3, 4, 3);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Some worksheet text to demonstrate scrolling. */</span></div>
<div class="line">    <span class="keywordflow">for</span> (col = 0; col &lt; 9; col++) {</div>
<div class="line">        <a name="a17"></a><a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet1, 0, col, <span class="stringliteral">&quot;Scroll down&quot;</span>, header);</div>
<div class="line">    }</div>
<div class="line"> </div>
<div class="line">    <span class="keywordflow">for</span> (row = 1; row &lt; 100; row++) {</div>
<div class="line">        <span class="keywordflow">for</span> (col = 0; col &lt; 9; col++) {</div>
<div class="line">            <a name="a18"></a><a class="code" href="worksheet_8h.html#ad9fc47d3beaa2ab4759414e8580c2289">worksheet_write_number</a>(worksheet1, row, col, row + 1, center);</div>
<div class="line">        }</div>
<div class="line">    }</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/*</span></div>
<div class="line"><span class="comment">     * Example 2. Freeze pane on the left column.</span></div>
<div class="line"><span class="comment">     */</span></div>
<div class="line">    <a class="code" href="worksheet_8h.html#a7e52f1eecb20fe4f9e6223bcf195103b">worksheet_freeze_panes</a>(worksheet2, 0, 1);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Some sheet formatting. */</span></div>
<div class="line">    <a class="code" href="worksheet_8h.html#a9656e4e05d3787eee6b3e4d8e82d9b7f">worksheet_set_column</a>(worksheet2, 0, 0, 16, NULL);</div>
<div class="line">    <a class="code" href="worksheet_8h.html#a62368aa313184d72a9ca2b1cf5de9a8a">worksheet_set_selection</a>(worksheet2, 4, 3, 4, 3);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Some worksheet text to demonstrate scrolling. */</span></div>
<div class="line">    <span class="keywordflow">for</span> (row = 0; row &lt; 50; row++) {</div>
<div class="line">        <a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet2, row, 0, <span class="stringliteral">&quot;Scroll right&quot;</span>, header);</div>
<div class="line"> </div>
<div class="line">        <span class="keywordflow">for</span> (col = 1; col &lt; 26; col++) {</div>
<div class="line">            <a class="code" href="worksheet_8h.html#ad9fc47d3beaa2ab4759414e8580c2289">worksheet_write_number</a>(worksheet2, row, col, col, center);</div>
<div class="line">        }</div>
<div class="line">    }</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/*</span></div>
<div class="line"><span class="comment">     * Example 3. Freeze pane on the top row and left column.</span></div>
<div class="line"><span class="comment">     */</span></div>
<div class="line">    <a class="code" href="worksheet_8h.html#a7e52f1eecb20fe4f9e6223bcf195103b">worksheet_freeze_panes</a>(worksheet3, 1, 1);</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Some sheet formatting. */</span></div>
<div class="line">    <a class="code" href="worksheet_8h.html#a9656e4e05d3787eee6b3e4d8e82d9b7f">worksheet_set_column</a>(worksheet3, 0, 25, 16, NULL);</div>
<div class="line">    <a class="code" href="worksheet_8h.html#ab9b7fb95e1bd9b0da70befd0d37a9173">worksheet_set_row</a>(worksheet3, 0, 20, NULL);</div>
<div class="line">    <a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet3, 0, 0, <span class="stringliteral">&quot;&quot;</span>, header);</div>
<div class="line">    <a class="code" href="worksheet_8h.html#a62368aa313184d72a9ca2b1cf5de9a8a">worksheet_set_selection</a>(worksheet3, 4, 3, 4, 3);</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Some worksheet text to demonstrate scrolling. */</span></div>
<div class="line">    <span class="keywordflow">for</span> (col = 1; col &lt; 26; col++) {</div>
<div class="line">        <a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet3, 0, col, <span class="stringliteral">&quot;Scroll down&quot;</span>, header);</div>
<div class="line">    }</div>
<div class="line"> </div>
<div class="line">    <span class="keywordflow">for</span> (row = 1; row &lt; 50; row++) {</div>
<div class="line">        <a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet3, row, 0, <span class="stringliteral">&quot;Scroll right&quot;</span>, header);</div>
<div class="line"> </div>
<div class="line">        <span class="keywordflow">for</span> (col = 1; col &lt; 26; col++) {</div>
<div class="line">            <a class="code" href="worksheet_8h.html#ad9fc47d3beaa2ab4759414e8580c2289">worksheet_write_number</a>(worksheet3, row, col, col, center);</div>
<div class="line">        }</div>
<div class="line">    }</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/*</span></div>
<div class="line"><span class="comment">     * Example 4. Split pane on the top row and left column.</span></div>
<div class="line"><span class="comment">     *</span></div>
<div class="line"><span class="comment">     * The divisions must be specified in terms of row and column dimensions.</span></div>
<div class="line"><span class="comment">     * The default row height is 15 and the default column width is 8.43</span></div>
<div class="line"><span class="comment">     */</span></div>
<div class="line">    <a name="a19"></a><a class="code" href="worksheet_8h.html#a9f4a3845529bcc2922b89bdb450ded32">worksheet_split_panes</a>(worksheet4, 15, 8.43);</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Some sheet formatting. */</span></div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Some worksheet text to demonstrate scrolling. */</span></div>
<div class="line">    <span class="keywordflow">for</span> (col = 1; col &lt; 26; col++) {</div>
<div class="line">        <a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet4, 0, col, <span class="stringliteral">&quot;Scroll&quot;</span>, center);</div>
<div class="line">    }</div>
<div class="line"> </div>
<div class="line">    <span class="keywordflow">for</span> (row = 1; row &lt; 50; row++) {</div>
<div class="line">        <a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet4, row, 0, <span class="stringliteral">&quot;Scroll&quot;</span>, center);</div>
<div class="line"> </div>
<div class="line">        <span class="keywordflow">for</span> (col = 1; col &lt; 26; col++) {</div>
<div class="line">            <a class="code" href="worksheet_8h.html#ad9fc47d3beaa2ab4759414e8580c2289">worksheet_write_number</a>(worksheet4, row, col, col, center);</div>
<div class="line">        }</div>
<div class="line">    }</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <a name="a20"></a><a class="code" href="workbook_8h.html#ad9e7aeebc0fd43562db5bcd527b2ee5e">workbook_close</a>(workbook);</div>
<div class="line"> </div>
<div class="line">    <span class="keywordflow">return</span> 0;</div>
<div class="line">}</div>
</div><!-- fragment --> </div><!-- contents -->
<div class="ttc" id="aworkbook_8h_html_ad9e7aeebc0fd43562db5bcd527b2ee5e"><div class="ttname"><a href="workbook_8h.html#ad9e7aeebc0fd43562db5bcd527b2ee5e">workbook_close</a></div><div class="ttdeci">lxw_error workbook_close(lxw_workbook *workbook)</div><div class="ttdoc">Close the Workbook object and write the XLSX file.</div></div>
<div class="ttc" id="aformat_8h_html_adeeb0d70c7c873422d642323e7e1ecf5ae0a52569d3110521d3e9341809336063"><div class="ttname"><a href="format_8h.html#adeeb0d70c7c873422d642323e7e1ecf5ae0a52569d3110521d3e9341809336063">LXW_ALIGN_VERTICAL_CENTER</a></div><div class="ttdeci">@ LXW_ALIGN_VERTICAL_CENTER</div><div class="ttdef"><b>Definition:</b> format.h:153</div></div>
<div class="ttc" id="aformat_8h_html_a189c83d1f21b01937f1f730720c33d13"><div class="ttname"><a href="format_8h.html#a189c83d1f21b01937f1f730720c33d13">format_set_align</a></div><div class="ttdeci">void format_set_align(lxw_format *format, uint8_t alignment)</div><div class="ttdoc">Set the alignment for data in the cell.</div></div>
<div class="ttc" id="aworkbook_8h_html_a1cf96608a23ee4eb0e8467c15240d00b"><div class="ttname"><a href="workbook_8h.html#a1cf96608a23ee4eb0e8467c15240d00b">workbook_new</a></div><div class="ttdeci">lxw_workbook * workbook_new(const char *filename)</div><div class="ttdoc">Create a new workbook object.</div></div>
<div class="ttc" id="aworksheet_8h_html_a62368aa313184d72a9ca2b1cf5de9a8a"><div class="ttname"><a href="worksheet_8h.html#a62368aa313184d72a9ca2b1cf5de9a8a">worksheet_set_selection</a></div><div class="ttdeci">void worksheet_set_selection(lxw_worksheet *worksheet, lxw_row_t first_row, lxw_col_t first_col, lxw_row_t last_row, lxw_col_t last_col)</div><div class="ttdoc">Set the selected cell or cells in a worksheet:</div></div>
<div class="ttc" id="aformat_8h_html_a9cf7a28a6e8014cb98dff27415e2b1ca"><div class="ttname"><a href="format_8h.html#a9cf7a28a6e8014cb98dff27415e2b1ca">format_set_border</a></div><div class="ttdeci">void format_set_border(lxw_format *format, uint8_t style)</div><div class="ttdoc">Set the cell border style.</div></div>
<div class="ttc" id="aformat_8h_html_a85e1b0baf44b445b65894e48722aec14"><div class="ttname"><a href="format_8h.html#a85e1b0baf44b445b65894e48722aec14">format_set_bold</a></div><div class="ttdeci">void format_set_bold(lxw_format *format)</div><div class="ttdoc">Turn on bold for the format font.</div></div>
<div class="ttc" id="astructlxw__worksheet_html"><div class="ttname"><a href="structlxw__worksheet.html">lxw_worksheet</a></div><div class="ttdoc">Struct to represent an Excel worksheet.</div><div class="ttdef"><b>Definition:</b> worksheet.h:1603</div></div>
<div class="ttc" id="astructlxw__format_html"><div class="ttname"><a href="structlxw__format.html">lxw_format</a></div><div class="ttdoc">Struct to represent the formatting properties of an Excel format.</div><div class="ttdef"><b>Definition:</b> format.h:358</div></div>
<div class="ttc" id="aformat_8h_html_adeeb0d70c7c873422d642323e7e1ecf5a9899936ef3a43721b394b9b5d2314496"><div class="ttname"><a href="format_8h.html#adeeb0d70c7c873422d642323e7e1ecf5a9899936ef3a43721b394b9b5d2314496">LXW_ALIGN_CENTER</a></div><div class="ttdeci">@ LXW_ALIGN_CENTER</div><div class="ttdef"><b>Definition:</b> format.h:129</div></div>
<div class="ttc" id="aformat_8h_html_a65086b2b6ee51fd34893e3c53e0578eb"><div class="ttname"><a href="format_8h.html#a65086b2b6ee51fd34893e3c53e0578eb">format_set_fg_color</a></div><div class="ttdeci">void format_set_fg_color(lxw_format *format, lxw_color_t color)</div><div class="ttdoc">Set the pattern foreground color for a cell.</div></div>
<div class="ttc" id="astructlxw__workbook_html"><div class="ttname"><a href="structlxw__workbook.html">lxw_workbook</a></div><div class="ttdoc">Struct to represent an Excel workbook.</div><div class="ttdef"><b>Definition:</b> workbook.h:273</div></div>
<div class="ttc" id="aworksheet_8h_html_ac208046e7a6d12cc87982422efa41b31"><div class="ttname"><a href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a></div><div class="ttdeci">lxw_error worksheet_write_string(lxw_worksheet *worksheet, lxw_row_t row, lxw_col_t col, const char *string, lxw_format *format)</div><div class="ttdoc">Write a string to a worksheet cell.</div></div>
<div class="ttc" id="aworksheet_8h_html_ab9b7fb95e1bd9b0da70befd0d37a9173"><div class="ttname"><a href="worksheet_8h.html#ab9b7fb95e1bd9b0da70befd0d37a9173">worksheet_set_row</a></div><div class="ttdeci">lxw_error worksheet_set_row(lxw_worksheet *worksheet, lxw_row_t row, double height, lxw_format *format)</div><div class="ttdoc">Set the properties for a row of cells.</div></div>
<div class="ttc" id="aworksheet_8h_html_ad9fc47d3beaa2ab4759414e8580c2289"><div class="ttname"><a href="worksheet_8h.html#ad9fc47d3beaa2ab4759414e8580c2289">worksheet_write_number</a></div><div class="ttdeci">lxw_error worksheet_write_number(lxw_worksheet *worksheet, lxw_row_t row, lxw_col_t col, double number, lxw_format *format)</div><div class="ttdoc">Write a number to a worksheet cell.</div></div>
<div class="ttc" id="aworksheet_8h_html_a7e52f1eecb20fe4f9e6223bcf195103b"><div class="ttname"><a href="worksheet_8h.html#a7e52f1eecb20fe4f9e6223bcf195103b">worksheet_freeze_panes</a></div><div class="ttdeci">void worksheet_freeze_panes(lxw_worksheet *worksheet, lxw_row_t row, lxw_col_t col)</div><div class="ttdoc">Split and freeze a worksheet into panes.</div></div>
<div class="ttc" id="aworksheet_8h_html_a9f4a3845529bcc2922b89bdb450ded32"><div class="ttname"><a href="worksheet_8h.html#a9f4a3845529bcc2922b89bdb450ded32">worksheet_split_panes</a></div><div class="ttdeci">void worksheet_split_panes(lxw_worksheet *worksheet, double vertical, double horizontal)</div><div class="ttdoc">Split a worksheet into panes.</div></div>
<div class="ttc" id="aworksheet_8h_html_a9656e4e05d3787eee6b3e4d8e82d9b7f"><div class="ttname"><a href="worksheet_8h.html#a9656e4e05d3787eee6b3e4d8e82d9b7f">worksheet_set_column</a></div><div class="ttdeci">lxw_error worksheet_set_column(lxw_worksheet *worksheet, lxw_col_t first_col, lxw_col_t last_col, double width, lxw_format *format)</div><div class="ttdoc">Set the properties for one or more columns of cells.</div></div>
<div class="ttc" id="aformat_8h_html_a4d5e924b1acd9571fd5e0fe2615e9f8fa7ca212fb42e5816bb81d7b96ff623082"><div class="ttname"><a href="format_8h.html#a4d5e924b1acd9571fd5e0fe2615e9f8fa7ca212fb42e5816bb81d7b96ff623082">LXW_BORDER_THIN</a></div><div class="ttdeci">@ LXW_BORDER_THIN</div><div class="ttdef"><b>Definition:</b> format.h:295</div></div>
<div class="ttc" id="aworkbook_8h_html_a81d456b4f65a464e78e4a0030ecc3c2e"><div class="ttname"><a href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a></div><div class="ttdeci">lxw_worksheet * workbook_add_worksheet(lxw_workbook *workbook, const char *sheetname)</div><div class="ttdoc">Add a new worksheet to a workbook.</div></div>
<div class="ttc" id="aworkbook_8h_html_a279a5d7075d09a3931aae9782afede33"><div class="ttname"><a href="workbook_8h.html#a279a5d7075d09a3931aae9782afede33">workbook_add_format</a></div><div class="ttdeci">lxw_format * workbook_add_format(lxw_workbook *workbook)</div><div class="ttdoc">Create a new Format object to formats cells in worksheets.</div></div>
<!-- HTML footer for doxygen 1.8.20-->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Copyright 2014-2020 John McNamara.
Generated by&#160;<a href="http://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.8.20
</small></address>
</body>
</html>
